use master
go
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'sp_SqlBits_Scripter_GetObjectScript')
  drop procedure [dbo].[sp_SqlBits_Scripter_GetObjectScript]
GO
use MSDB
go
/****** Object:  StoredProcedure [dbo].[sp_SqlBits_Scripter_GetObjectScript]    Script Date: 04/20/2007 00:11:24 ******/
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'up_SqlBits_Scripter_GetObjectScript')
  drop procedure [dbo].[up_SqlBits_Scripter_GetObjectScript]
go
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'up_SqlBits_Scripter_ReturnScriptRequest')
  drop procedure [dbo].[up_SqlBits_Scripter_ReturnScriptRequest]
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'up_SqlBits_Scripter_ReceiveScriptRequest')
  drop procedure [dbo].[up_SqlBits_Scripter_ReceiveScriptRequest]
GO
if exists (select 1 from sys.services where name = 'SqlBits.Scripter.GeneratorService')
  drop service [SqlBits.Scripter.GeneratorService]
go
if exists (select 1 from sys.services where name = 'SqlBits.Scripter.ResponseService')
  drop service [SqlBits.Scripter.ResponseService]
go
if exists (select 1 from sys.service_queues where name = 'SqlBits.Scripter.GeneratorQueue')
  drop queue [SqlBits.Scripter.GeneratorQueue]
go
if exists (select 1 from sys.service_queues where name = 'SqlBits.Scripter.ResponseQueue')
  drop queue [SqlBits.Scripter.ResponseQueue]
go
--drop service [SQLBits.Scripter.GeneratorService]
--drop service [SQLBits.Scripter.ResponseService]
